Database administrator (DBA) with around 11 years extensive experience of designing, coding, testing and supporting next-generation database solutions in Oracle enterprise and SQL Server environments.
Implementing RAC, Data guard, backup and recovery strategies, database cloning, performance tuning, Golden Gate and implementing business logic using sql,Pl/Sql functions, packages and triggers.
Proficient in an assortment of technologies, including Oracle 12c, DB2, MS SQL Server 2014 ,My Sql NDB cluster ,PostgreSql ,Mongo DB , Windows and Linux.
Vast experience of different domains like Textile, Telecom, Medical record keeping and billing and Oil &Gas
• Working as Corporate Data Store (CDS) and OpenWorks Database administrator.
• Setup RAC from scratch and Management of Oracle11gR2 Real Application Cluster and Grid infrastructure.
• Add and remove node from Cluster.
• Configuration and Administration of Standby Database with Oracle Data Guard.
• Using RMAN to create Incremental Backups, manage and configure backup policy and automate it to ensure that database backups are working according to backup and recovery policy.
• Good skills in Oracle Data Pump Utility, Export and Import Utility and SQL Loader.
• Working with Oracle Golden Gate to duplicate, backup database to other systems.
• Good experience of managing ASM instance.
• Database software installation, patching and cloning.
• Expertise in managing Table spaces, Data files, Users and Privileges, Tables, Schema, Materialized Views ,indexes ,partitioning and other database objects.
• Experience in Data Warehouse database design, database support and maintenance, Security, monitoring and troubleshooting, Capacity planning, Partitioning.
• Sql,Pl/Sql and Database Performance tuning using Oracle Enterprise manager , Oracle Trace, Explain Plan.
• Using SSIS and Sql scripts to write ETL jobs to migrate data.
• Writing Optimized SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, and Views
• Working Experience of Configuration and Management of Oracle11gR2 RAC, ASM infrastructure.
• Good Experience in writing complex SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, Views and Materialized Views.
• Configuration and Administration of Standby Database with Oracle Active Data Guard.
• Expertise in RMAN to create Incremental Backups, manage and configure backup policy and automate it to ensure that database backups are working according to backup and recovery policy.
• Database Upgrades, Migrations, Cloning, Patching, and troubleshooting various databases
• Expertise in managing Table spaces, Data files, Users and Privileges, Tables, Schema, Materialized Views, Indexes and other database objects.
• Implementing Virtual Private Database (VPD),Implementing Oracle Label Security (OLS) , Working knowledge of Transparent Data Encryption (TDE) and Basic knowledge of Oracle Data Redaction (ODR)
• Managing Full-Text Indexing
• Implementation Database replication, database mirroring.
• Creating and managing MySQL on NDB cluster.
• Managing PostgreSQL database. Implementing PostgreSQL database replication, switchover and failover.
• Managing Sql Server 2014 database implementing backup and recovery for Sql server database, scheduling jobs, writing store procedures, functions.
• Migrating data to and from Sql server database.
• IBM DB2 and Mongo DB Database Administration and development.
• Setup RAC from scratch and Management of Oracle11gR2 Real Application Cluster and Grid infrastructure.
• Configuration and Administration of Standby Database with Oracle Data Guard.
• Using RMAN to create Incremental Backups, manage and configure backup policy and automate it to ensure that database backups are working according to backup and recovery policy.
• Good skills in Oracle Data Pump Utility, Export and Import Utility and SQL Loader.
• Good experience of managing ASM instance.
• Database software installation, patching and cloning.
• Expertise in managing Table spaces, Data files, Users and Privileges, Tables, Schema, Materialized Views ,indexes ,partitioning and other database objects.
• Set up and manage database security creating new users, roles, profiles, and grant required user privileges.
• Sql,Pl/Sql and Database Performance tuning using Oracle Enterprise manager , Oracle Trace, Explain Plan.
• Writing Optimized SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, and Views and Materialized Views.
• Administer production and development databases, ensuring maximum availability.
• Design, implement and operate database systems for performance and reliability.
• Ensure that storage, archiving, back-up and recovery procedures are functioning correctly
• Apply business Logic through Procedure, Functions and Packages triggers and writing complex queries.
• Work with customers in data migration projects to build migration scripts and integrate with customer’s existing databases and/or data feeds
• Review database design and code written by other database and software engineers.
• Writing ETL scripts and provide technical assistance to BI development, application Development and support team.
• Using SQL Server 2000, 2005, 2008 database administration and development.
• Applying Backup and Recovery methods, backup tuning and troubleshooting
• Involved in designing, developing and deploying application.
• Apply business Logic through Procedure, Functions and Packages triggers and writing complex queries.
• Providing Support to off sure clients.
• Working experience in Oracle forms ,Oracle reports ,Oracle graphic
• Good Experience in writing complex SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, Views and Materialized Views.
• Write Ad hock queries to generate different reports and to extract data for analysis and decision making.
• Managing database, creating Users and Privileges, Tables, Schema, Materialized Views, Adding tablespace, Data files.
• Working experience in Oracle Forms ,Oracle Reports ,Oracle graphic
• Good Experience in writing complex SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, Views and Materialized Views.
• Write complex queries to generate different reports and to extract data for analysis and decision making.
• Writing Ad hock queries to extract data for analysis purpose